SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create view [dbo].[agentes_por_asignatura]
as
select distinct agente,a.descripcion,po.cuise from vw_pofpaquetes po inner join tb_plazas p on p.cupof = po.cupof inner join tb_asignaturas a on idasignatura = p.asignatura where agente <> 'vacante'
GO
